
using Youz.Common.Entity;
using Youz.Common.Helper;
using Youz.CreditRepay.DAL;
using Youz.CreditRepay.Entity;
using System;
using System.Data;
using System.Data.SqlClient;

namespace Youz.CreditRepay.BLL
{
	/// <summary>
	/// Sys_Version BLL Class
	/// </summary>
	public partial class Sys_VersionBLL : BaseBLL
	{
		Sys_VersionDAL dal;
		
		public Sys_VersionBLL()
		{
			dal = new Sys_VersionDAL();
			base.ModuleName = "Sys_Version";
			base.MenuName = "Sys_Version";
		}

		#region  成员方法
		/// <summary>
		///  新增一条数据
		/// </summary>
		public bool Add(Sys_Version model)
		{
			var r = dal.Add(model);
			
			base.WriteOperationLog(OperationType.Add, r, Core.GetJsonByObjectHaveTime(model));

			return r;
		}

		/// <summary>
		///  保存一条数据
		/// </summary>
		public bool Update(Sys_Version model)
		{
			var r = dal.Update(model);
			
			base.WriteOperationLog(OperationType.Update, r, Core.GetJsonByObjectHaveTime(model));

			return r;
		}

		/// <summary>
		/// 删除一条数据
		///</summary>
		public bool Delete(Guid VersionID)
		{
			var r = dal.Delete(VersionID);
			
			base.WriteOperationLog(OperationType.Delete, r, VersionID);

			return r;
		}

		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public Sys_Version Get(Guid VersionID)
		{
			return dal.Get(VersionID);
		}
		
		/// <summary>
		/// 得到一个JSON对象
		/// </summary>
		public string GetJson(Guid VersionID)
		{
			return Core.GetJsonByObject(Get(VersionID));
		}

		/// <summary>
		/// 获得数据列表
		/// </summary>
		public DataSet Gets(string sqlWhere)
		{
			return dal.Gets(sqlWhere);
		}
		
		/// <summary>
		/// 获得前几行数据
		/// </summary>
		public DataSet Gets(int top, string sqlWhere, string filedOrder)
		{
			return dal.Gets(top, sqlWhere, filedOrder);
		}

        public Sys_Version GetLatest()
        {
            var row = CommonHelper.GetDataRow(Gets(1, "[Status]=1", "CreateTime desc"));
            return dal.Get(row);
        }
		
		/// <summary>
		/// 获取记录总数
		/// </summary>
		public int GetRecordCount(string sqlWhere)
		{
			return dal.GetRecordCount(sqlWhere);
		}
		
		/// <summary>
		/// 获得数据列表分页
		/// </summary>
		public DataTable Gets(string sqlWhere, int pageindex, int pagesize, out int total, params SqlParameter[] cmdParms)
		{
			return dal.Gets(sqlWhere, pageindex, pagesize, out total, cmdParms);
		}
		#endregion  成员方法
	}
}


  